15. Conclusions Using Query

Drawing Conclusions Using Query

In the notebook below, you're going to investigate two questions about this data using pandas' query function. Here are tips for answering each question:

Q1: Do wines with higher alcoholic content receive better ratings?

To answer this question, use query to create two groups of wine samples:

  1. Low alcohol (samples with an alcohol content less than the median)
  2. High alcohol (samples with an alcohol content greater than or equal to the median)

Then, find the mean quality rating of each group.

Q2: Do sweeter wines (more residual sugar) receive better ratings?

Similarly, use the median to split the samples into two groups by residual sugar and find the mean quality rating of each group.

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: jupyter
  • Opened files (when workspace is loaded): n/a

Do wines with higher alcoholic content generally receive better ratings?

SOLUTION: Yes

Do sweeter wines generally receive higher ratings?

SOLUTION: Yes

Next Concept